1 What is Hortonworks?

2 Why Hortonworks Data Platform (HDP)?

3 HDP 2.x

The HDP (2.x) distribution increasingly incorporates many innovations in the Hadoop ecosystem

4 HDP 3.x

5 What is Hortonworks Sandbox?

6 HCatalog

7 Ambari

A completely open framework for provisioning, managing and monitoring Apache Hadoop clusters

8 Access the Linux Shell Web Client

9 Access Hortonworks Sandbox via Ambari

Username Password Roles
raj_ops raj_ops For infrastructure build and R&D activities
maria_dev maria_dev For preparing and getting insight from data
holger_gov holger_gov For the management of data elements
amy_ds amy_ds For exploratory data analysis, cleanup and transformation

10 Reset Ambari the admin Password

ambari-admin-password-reset
ambari-agent restart

11 Using Ambari: the User Views

12 Ambari User Views: Files View

12.1 Browse Files

12.2 Click “Open” to Preview a File

12.3 Click “Permissions” to Change Permissions of a File

pending

12.4 Click “Download” to Download a File to Your Local OS (Mac or Windows)

12.5 Click “Upload” to Upload a File from Your Local OS (Mac or Windows)




13 Ambari User Views: Hive View There are Two Hive Views

14 Ambari User Views: Hive View

14.1 Prepare to Upload/Create a Table

  • Change file permissions to 777 (often) in Files View
  • Set right delimiter and import row header if any

14.2 Upload/Create a Table


14.3 Get a Description of a Table

14.4 An SQL Query

15 Ambari User Views: Pig View